Column

INTRO

The data set is about Registered business locations in San Francisco maintained by the Office of Treasurer-Tax Collector, including business locations that have been sold, closed, or moved out of San Francisco. The main data set has 13 columns and 282,000 rows. The data last updated in Nov 13th 2021. The second data set was used to add the values of latitude and longitude by the location ID.

Source of data set: Main sata set: https://data.sfgov.org/Economy-and-Community/Registered-Businesses-sorted-by-End-Date/vupz-6rcv

https://data.sfgov.org/Economy-and-Community/Map-of-Registered-Businesses-San-Francisco/9tqe-vdng

The 13 variables include the followings:

1/Location ID: Location identifier

2/ Business Account Number: Seven digit number assigned to registered business accounts

3/ Ownership Name: Business owner(s) name

4/ DBA Name: Doing Business As Name or Location Name

5/ Street Address: Business location street address

6/ City: Business location city

7/ State: Business location state

8/ Source Zipcode: Business location zip code

9/ Business Start Date: Start date of the business

10/ Business End Date: End date of the business

11/ Location Start Date: Start date at the location

12/ Location End Date: End date at the location, if closed

13/ Mail Address: Address for mailing.

The selection of this data set aims to examine the opening and closing of businesses in the city with the highest business count. The inquiry revolves around the impact of the pandemic on businesses in that locale and the spatial distribution of these establishments. The data set holds the potential to unveil insights into these research inquiries.

Initially, the gathered data indicates the top five cities in California with the most significant number of businesses:

San Francisco 231675
Oakland 3518
Daly City 2499
San Jose 1799
Hayward 1101



City Number of Businesses
San Francisco 231,675
Oakland 3,518
Daly City 2,499
San Jose 1,799
Hayward 1,101
Richmond 996
Berkeley 862
Sacramento 793
Concord 763
San Rafael 709
... ...

Column {data-width=500}

1st Analysis

Among these cities, San Francisco has experienced the highest volume of registered business so far.

2nd Analysis

Based on the dataset, San Francisco saw 5,295 new businesses registered in 2021. New businesses tend to commence operations at the start of the year.

     n
1 5295

3rd Analysis

Observing the past five years, a significant surge in business closures occurred in 2018, coinciding with the onset of the pandemic in early 2020, persisting to the present. Hence, Covid-19 does not solely account for the closures of business establishments in San Francisco. Rather, a shift in consumer behavior from in-store to online shopping may be another contributing factor.

However, despite the high closure rate in 2018, there was also a substantial number of new businesses launched, indicating a bustling market environment. Conversely, in 2021, although the closure rate decreased compared to 2018, the number of new businesses appears relatively modest. The subdued volume of new businesses in 2020 and 2021 may signal a sluggish economic growth in San Francisco.

                The number of new business in San Francisco.

4th Analysis

The map depicts businesses spread across various locations in San Francisco, with the most active areas situated in zip codes 94109, 94110, and 94111.

5th Analysis

In conclusion, active businesses show a decreasing trend over the years. The patterns illustrated in Figure 1 depict the trend of active businesses over a 10-year cycle. This suggests the possibility of an economic downturn similar to previous occurrences.

        Figure 1 - The trend of active businesses in San Francisco

                Figure 2 - Histogram of active businesses in San Francisco